﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_ProductCategory') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_ProductCategory
END
GO
create view V_ProductCategory
      as select [ID] 
      ,[Name] 
      ,[Keywords] 
      ,[Description]
      ,[OrderID] 
      ,[CategoryLevel]
      ,[FatherID]
      from  [dbo].[ShopNum1_ProductCategory]
	  where [IsShow]=1 and [IsDeleted]=0